UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1ZjLQGyfTwXBnCgTkd+odtV35mKM+M+wi2e7Cqy6zU='
WHERE
key_id = '2ce0ddcdfe68be9ca43b16fdd06e5ea6f6e446f1cf1deaa121502c452522121d'
AND (
token = 'z1ZjLQGyfTwXBnCgTkd+odtV35mKM+M+wi2e7Cqy6zU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)