UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9mPQb7OjaznaI1Z6fgcgLynJyFrRjRn8mHHI30oK29o='
WHERE
key_id = '9e8f2202c7a223c2c87ae2b41ce43bd76eefb0f8a9825689663179de35ef930b'
AND (
token = '9mPQb7OjaznaI1Z6fgcgLynJyFrRjRn8mHHI30oK29o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)