UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZcHhjq9FVI5OmsNrE9X577KwgtBL9tJO+gkwkr/tnms='
WHERE
key_id = 'ff3057e79d63581602325bc48214b0186ed05495b2cb0d670d3132d79434f996'
AND (
token = 'ZcHhjq9FVI5OmsNrE9X577KwgtBL9tJO+gkwkr/tnms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)