UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ihAH/Yc7YoUtlyeGxFcOrMZjrw9OIukjbvYGG49ZE4='
WHERE
key_id = 'cdf3fc4f57e301c45cea325624a3230e46c05846893c227c678b8cade3880f2e'
AND (
token = '1ihAH/Yc7YoUtlyeGxFcOrMZjrw9OIukjbvYGG49ZE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)