UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9HZcktcS3QM5girXEXAEYWy+3Ju2Lk/pZynRHLQhjsw='
WHERE
key_id = '790e5b4520af1f759101b45138751a545cdb05913b4cee460103a179e9b82dcd'
AND (
token = '9HZcktcS3QM5girXEXAEYWy+3Ju2Lk/pZynRHLQhjsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)