UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPTj646DrNz3PV4XXdaxZu58iXX7b4Ue5YLvJcepljs='
WHERE
key_id = '7566af746b9749a2537f0e35a3df997a47b70faeb3173e62562fd3ad7700ca56'
AND (
token = 'BPTj646DrNz3PV4XXdaxZu58iXX7b4Ue5YLvJcepljs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)