UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F8zIRUij1mSsiuNBzQ71IVuZ8edTvZ8Gr/slmjjxlcw='
WHERE
key_id = '95f93edc52f2f3eacf522d1539721b868bdaa52e950445486af5197dc9f33c4f'
AND (
token = 'F8zIRUij1mSsiuNBzQ71IVuZ8edTvZ8Gr/slmjjxlcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)