UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sdmbrdUnwoWzyRcoqATUJM5kq0xYWc6S+CFFHCX/8Mw='
WHERE
key_id = '2e9fabe204b2de3b6eb6cd7d50ec33976194da2f8005ccde8a932330f098973b'
AND (
token = 'sdmbrdUnwoWzyRcoqATUJM5kq0xYWc6S+CFFHCX/8Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)