UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHidHk4hJUdwp2aPtwXBWfHEDZaOGRD5ntjBGPPCQbU='
WHERE
key_id = '8e23089a7bf3c2b85389351b3d081176981d129f639bceec8667ff6ddfb4bf8a'
AND (
token = 'xHidHk4hJUdwp2aPtwXBWfHEDZaOGRD5ntjBGPPCQbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)