UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DMHsg1l274oGsLOPGeMLfuYx3mldt0jEc7JwtCHjWiE='
WHERE
key_id = 'c16d7537ae4de06e1e346473362e1486b096a9356eb072c7e6b0f1f93055a7b8'
AND (
token = 'DMHsg1l274oGsLOPGeMLfuYx3mldt0jEc7JwtCHjWiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)