UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4/791cGP6EjKn/Ew8rzRh1xhr1/I7OTUPVkm5ssfQI='
WHERE
key_id = 'ba7731b31eec5376305f42b0c592db7b9adb0be88921889b41dc7448f2f035f1'
AND (
token = 'a4/791cGP6EjKn/Ew8rzRh1xhr1/I7OTUPVkm5ssfQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)