UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OZyiJy/V46iiYQGYlNKctTTt5WW37s47mtRsT9x1iio='
WHERE
key_id = '78c4ad002aef4de84393e0f5e7d61de999aa92f51f97f8da11df06622ff080be'
AND (
token = 'OZyiJy/V46iiYQGYlNKctTTt5WW37s47mtRsT9x1iio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)