UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnGiSXkHhSDk8QaiHA/BSULxx21ENwrp8H6Le0lDeO8='
WHERE
key_id = 'b875e312fa6fabd4643f645deb7c78c5bba57c56dc4a6f29999175df2f16a959'
AND (
token = 'ZnGiSXkHhSDk8QaiHA/BSULxx21ENwrp8H6Le0lDeO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)