UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4WI8DrQpQZLQ75xXp7MDdfmU+F+Ty3l91M1PZ4npfes='
WHERE
key_id = '418312d19ce3f1a6b4a30d851df9bc44578ca3b47b9a43dfef8992707dfafe8e'
AND (
token = '4WI8DrQpQZLQ75xXp7MDdfmU+F+Ty3l91M1PZ4npfes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)