UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V5UWlJuxey5wkjE9vZzlXmrxAyG9Fd2U5sweTJecSMs='
WHERE
key_id = '1bea4768d21bb04956f142764154e60efb99d0720d48916def7da2402f2f5608'
AND (
token = 'V5UWlJuxey5wkjE9vZzlXmrxAyG9Fd2U5sweTJecSMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)