UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jeogeht7YgZLTpv2b8o9GnKaTKMSllS+64J7Plw1yyc='
WHERE
key_id = '12c3ca81ee549ae0bc38f9c3c8dda783e96ac9499df727d6df65016fa912ff6b'
AND (
token = 'Jeogeht7YgZLTpv2b8o9GnKaTKMSllS+64J7Plw1yyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)