UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rc47AiQGc1DuJXBsg5zg5/LINaEcuDe6EOSKwZdwxNY='
WHERE
key_id = 'c0390c1d0cdda8cef29e171398300939a7d64e86d08ad813ce49389e2b5fa8b4'
AND (
token = 'rc47AiQGc1DuJXBsg5zg5/LINaEcuDe6EOSKwZdwxNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)