UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g4ahXUMlVFZ5j9A0KfxbZZYLYKfIpvibbFeckZ/+Tn0='
WHERE
key_id = '8cab36b1a097ef5e84440ebabad512ae688c8cabd88433d51cea630dd8c9b2b2'
AND (
token = 'g4ahXUMlVFZ5j9A0KfxbZZYLYKfIpvibbFeckZ/+Tn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)