UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '23L6Vz9uHYVgp3tgkAK+4w4wr90IYNefFBrT5/Z6uP8='
WHERE
key_id = '4f642c0eb68b925caad3981c03ed4dc9e8743fd688374714288202082ac06b40'
AND (
token = '23L6Vz9uHYVgp3tgkAK+4w4wr90IYNefFBrT5/Z6uP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)