UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JwDiZDafzzyV+mclju1kW9VYuzzxTlUTF1bjZk/S5Mg='
WHERE
key_id = 'c4ebce8871484e437870dae8ff12b56f0cc20ddef09c8ccf1949d3f27f893dab'
AND (
token = 'JwDiZDafzzyV+mclju1kW9VYuzzxTlUTF1bjZk/S5Mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)