UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u9RgwiYE5fS02Dxj2wk96HJR2NMcrkvilfU+h1uVp00='
WHERE
key_id = '5870219d68226f51926ca531790c78c346334635dc17e2255535b4a567988d3d'
AND (
token = 'u9RgwiYE5fS02Dxj2wk96HJR2NMcrkvilfU+h1uVp00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)