UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tb+7WVJ/lZSWWumVom3/orMH2cqpks77RuHoXrBjcfk='
WHERE
key_id = 'c540433de853a3d8902949e28a65f8b22aff5adda2eac15657ce665fc7aa4a1c'
AND (
token = 'Tb+7WVJ/lZSWWumVom3/orMH2cqpks77RuHoXrBjcfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)