UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9iNdTRWduzdkMMNXGuHpKQWdvpsLmMsmhk4misQmvK4='
WHERE
key_id = '50cc19e88806b619b6dbda196ea979e5450d819117df5730e162373ee8341364'
AND (
token = '9iNdTRWduzdkMMNXGuHpKQWdvpsLmMsmhk4misQmvK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)