UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3TDyJKe3t55nfYBYxyt16qYQ3rWaCze+3sGisVq5cNk='
WHERE
key_id = '8d6a7c5f301badc1f6ca620126ec949c75f880a4f5c6f95c8bb59c363a10ddb3'
AND (
token = '3TDyJKe3t55nfYBYxyt16qYQ3rWaCze+3sGisVq5cNk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)