UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8RpNH3uX0eiCxs6RHkt6lcn1BvkBaOLW89pGdjpwq44='
WHERE
key_id = '5a729caceff0eeac456fef1a96246776047d70297901d22707ebd042e6b398f3'
AND (
token = '8RpNH3uX0eiCxs6RHkt6lcn1BvkBaOLW89pGdjpwq44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)