UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rGTT8fWL5I/fVVLQcOYTyqGXxkcQcG87wNSdZPjCen0='
WHERE
key_id = '520e67fb4901daba34c0705f0f9fa955bc23501041afc29259e3acef4877337f'
AND (
token = 'rGTT8fWL5I/fVVLQcOYTyqGXxkcQcG87wNSdZPjCen0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)