UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1E4r5hLWq2KNAbpEeRL0CF0wkk/4H5LyrgHyy2ZWg0s='
WHERE
key_id = '7bea0fb0b6c574509947fc068c548375365e607ea28c4789539416a02cb5d6a2'
AND (
token = '1E4r5hLWq2KNAbpEeRL0CF0wkk/4H5LyrgHyy2ZWg0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)