UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'soQZ5Y6GKN4R3+EEsymabfv1dKnYMj4vljJgWgfp1ls='
WHERE
key_id = '0b82112c644abcb014d31ff056927213148142d96c5b8f840540db48f347b907'
AND (
token = 'soQZ5Y6GKN4R3+EEsymabfv1dKnYMj4vljJgWgfp1ls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)