UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iUgr4OksA2kdeK/KHIKGMC9PipuYlSC/HL8omgVTgO4='
WHERE
key_id = '71b563e89a40bc7f25fef42d3b7302abc08d5163968455404a2a75267ca7ef53'
AND (
token = 'iUgr4OksA2kdeK/KHIKGMC9PipuYlSC/HL8omgVTgO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)