UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UGXCLadEblVbtoZQvaI+dNXaFnvM2LD+QpBeKyIVr38='
WHERE
key_id = '8de2df2dd418e367fdab338652134beaf7a1ab867e85dbb0222fb5b5492f64fb'
AND (
token = 'UGXCLadEblVbtoZQvaI+dNXaFnvM2LD+QpBeKyIVr38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)