UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S524FJt/2crx1+S+2oHDddQ0zAsT8Jpa+7v9sXPqo+A='
WHERE
key_id = 'c6d2b03196b7a0b5dd85e16a70c6ff0c5fe824d3ecd1cc2e2c39d78ef2b47ddc'
AND (
token = 'S524FJt/2crx1+S+2oHDddQ0zAsT8Jpa+7v9sXPqo+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)